What is difference between SUBSTR and INSTR?
3404
31-Jan-2014
Sumit Kesarwani
31-Jan-2014INSTR function search string for sub-string and returns an integer indicating the position of the character in string that is the first character of this occurrence.SUBSTR function return a portion of string, beginning at character position, substring_length characters long.SUBSTR calculates lengths using characters as defined by the input character set.